To create a filtered index, specify which rows to include in the index.
Note: Support from SQL Server 2008 or later and SQL Azure.
Example:
StartDate > '20040101' AND EndDate <= '20040630'
To create a filtered index, specify which rows to include in the index.
Note: Support from SQL Server 2008 or later and SQL Azure.
Example:
StartDate > '20040101' AND EndDate <= '20040630'